Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PreferenceTypeCode (FK)(PK) | A unique code for a group of preferences. For instance, all the types of material (clothing) preferences may be grouped together. | TY_PRFC | Code2 | char(2) | PreferenceType(PA_PRFC_TYP) |
CustomerID (FK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | CustomerSurveyResponse(DO_SRVY_CT_RSPS) |
Description | A description of customers likes or dislikes of classes of items, colors, sizes, materials, etc. | DE_PRFC_CT | DescriptionNarrative | varchar(4000) | |
CustomerSurveyID (FK) | A unique retailer assigned identifier for the CustomerSurvery. | ID_SRVY_CT | Identity | integer | CustomerSurveyResponse(DO_SRVY_CT_RSPS) |
SurveyQuestionID (FK) | Unique retailer assigned identifier for the SurveyQuestion within the context of the CustomerSurvey. | ID_SRVY_QST | Identity | integer | CustomerSurveyResponse(DO_SRVY_CT_RSPS) |